Overview
Brought to you by YData
Dataset statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Number of variables | 14 | 14 |
| Number of observations | 41890 | 7391 |
| Missing cells | 0 | 0 |
| Missing cells (%) | 0.0% | 0.0% |
| Duplicate rows | 0 | 0 |
| Duplicate rows (%) | 0.0% | 0.0% |
| Total size in memory | 4.8 MiB | 866.1 KiB |
| Average record size in memory | 120.0 B | 120.0 B |
Variable types
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Numeric | 5 | 5 |
| Categorical | 7 | 7 |
| Text | 2 | 2 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
booking_complete has constant value "0" | booking_complete has constant value "1" | Constant |
trip_type is highly imbalanced (93.8%) | trip_type is highly imbalanced (97.8%) | Imbalance |
flight_hour has 1321 (3.2%) zeros | flight_hour has 180 (2.4%) zeros | Zeros |
| Alert not present in this dataset | sales_channel is highly imbalanced (59.9%) | Imbalance |
Reproduction
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Analysis started | 2024-12-24 09:11:23.024746 | 2024-12-24 09:11:28.147888 |
| Analysis finished | 2024-12-24 09:11:28.134940 | 2024-12-24 09:11:31.892330 |
| Duration | 5.11 seconds | 3.74 seconds |
| Software version | ydata-profiling vv4.12.1 | ydata-profiling vv4.12.1 |
| Download configuration | config.json | config.json |
Variables
num_passengers
Real number (ℝ)
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 9 | 9 |
| Distinct (%) | < 0.1% | 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 1.5798997 | 1.6484914 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 1 | 1 |
| Maximum | 9 | 9 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Quantile statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 1 | 1 |
| 5-th percentile | 1 | 1 |
| Q1 | 1 | 1 |
| median | 1 | 1 |
| Q3 | 2 | 2 |
| 95-th percentile | 4 | 4 |
| Maximum | 9 | 9 |
| Range | 8 | 8 |
| Interquartile range (IQR) | 1 | 1 |
Descriptive statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Standard deviation | 1.0079191 | 1.0622557 |
| Coefficient of variation (CV) | 0.63796398 | 0.64438047 |
| Kurtosis | 10.268054 | 9.1007124 |
| Mean | 1.5798997 | 1.6484914 |
| Median Absolute Deviation (MAD) | 0 | 0 |
| Skewness | 2.7118651 | 2.5618443 |
| Sum | 66182 | 12184 |
| Variance | 1.015901 | 1.1283871 |
| Monotonicity | Not monotonic | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 1 | 26476 | |
| 2 | 10640 | |
| 3 | 2396 | 5.7% |
| 4 | 1494 | 3.6% |
| 5 | 438 | 1.0% |
| 6 | 228 | 0.5% |
| 7 | 91 | 0.2% |
| 8 | 76 | 0.2% |
| 9 | 51 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4403 | |
| 2 | 2029 | |
| 3 | 486 | 6.6% |
| 4 | 273 | 3.7% |
| 5 | 106 | 1.4% |
| 6 | 53 | 0.7% |
| 7 | 16 | 0.2% |
| 9 | 13 | 0.2% |
| 8 | 12 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 26476 | |
| 2 | 10640 | |
| 3 | 2396 | 5.7% |
| 4 | 1494 | 3.6% |
| 5 | 438 | 1.0% |
| 6 | 228 | 0.5% |
| 7 | 91 | 0.2% |
| 8 | 76 | 0.2% |
| 9 | 51 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4403 | |
| 2 | 2029 | |
| 3 | 486 | 6.6% |
| 4 | 273 | 3.7% |
| 5 | 106 | 1.4% |
| 6 | 53 | 0.7% |
| 7 | 16 | 0.2% |
| 8 | 12 | 0.2% |
| 9 | 13 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 4403 | |
| 2 | 2029 | |
| 3 | 486 | 1.2% |
| 4 | 273 | 0.7% |
| 5 | 106 | 0.3% |
| 6 | 53 | 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 13 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 26476 | |
| 2 | 10640 | |
| 3 | 2396 | 32.4% |
| 4 | 1494 | 20.2% |
| 5 | 438 | 5.9% |
| 6 | 228 | 3.1% |
| 7 | 91 | 1.2% |
| 8 | 76 | 1.0% |
| 9 | 51 | 0.7% |
sales_channel
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 2 | 2 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| Internet | |
|---|---|
| Mobile |
| Internet | |
|---|---|
| Mobile | 589 |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 8 | 8 |
| Median length | 8 | 8 |
| Mean length | 7.772022 | 7.840617 |
| Min length | 6 | 6 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 325570 | 57950 |
| Distinct characters | 10 | 10 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | Internet | Internet |
| 2nd row | Internet | Internet |
| 3rd row | Internet | Internet |
| 4th row | Internet | Mobile |
| 5th row | Internet | Internet |
Common Values
| Value | Count | Frequency (%) |
| Internet | 37115 | |
| Mobile | 4775 | 11.4% |
| Value | Count | Frequency (%) |
| Internet | 6802 | |
| Mobile | 589 | 8.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| internet | 37115 | |
| mobile | 4775 | 11.4% |
| Value | Count | Frequency (%) |
| internet | 6802 | |
| mobile | 589 | 8.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 79005 | |
| n | 74230 | |
| t | 74230 | |
| I | 37115 | |
| r | 37115 | |
| M | 4775 | 1.5% |
| o | 4775 | 1.5% |
| b | 4775 | 1.5% |
| i | 4775 | 1.5% |
| l | 4775 | 1.5% |
| Value | Count | Frequency (%) |
| e | 14193 | |
| n | 13604 | |
| t | 13604 | |
| I | 6802 | |
| r | 6802 | |
| M | 589 | 1.0% |
| o | 589 | 1.0% |
| b | 589 | 1.0% |
| i | 589 | 1.0% |
| l | 589 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 325570 |
| Value | Count | Frequency (%) |
| (unknown) | 57950 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 79005 | |
| n | 74230 | |
| t | 74230 | |
| I | 37115 | |
| r | 37115 | |
| M | 4775 | 1.5% |
| o | 4775 | 1.5% |
| b | 4775 | 1.5% |
| i | 4775 | 1.5% |
| l | 4775 | 1.5% |
| Value | Count | Frequency (%) |
| e | 14193 | |
| n | 13604 | |
| t | 13604 | |
| I | 6802 | |
| r | 6802 | |
| M | 589 | 1.0% |
| o | 589 | 1.0% |
| b | 589 | 1.0% |
| i | 589 | 1.0% |
| l | 589 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 325570 |
| Value | Count | Frequency (%) |
| (unknown) | 57950 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 79005 | |
| n | 74230 | |
| t | 74230 | |
| I | 37115 | |
| r | 37115 | |
| M | 4775 | 1.5% |
| o | 4775 | 1.5% |
| b | 4775 | 1.5% |
| i | 4775 | 1.5% |
| l | 4775 | 1.5% |
| Value | Count | Frequency (%) |
| e | 14193 | |
| n | 13604 | |
| t | 13604 | |
| I | 6802 | |
| r | 6802 | |
| M | 589 | 1.0% |
| o | 589 | 1.0% |
| b | 589 | 1.0% |
| i | 589 | 1.0% |
| l | 589 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 325570 |
| Value | Count | Frequency (%) |
| (unknown) | 57950 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 79005 | |
| n | 74230 | |
| t | 74230 | |
| I | 37115 | |
| r | 37115 | |
| M | 4775 | 1.5% |
| o | 4775 | 1.5% |
| b | 4775 | 1.5% |
| i | 4775 | 1.5% |
| l | 4775 | 1.5% |
| Value | Count | Frequency (%) |
| e | 14193 | |
| n | 13604 | |
| t | 13604 | |
| I | 6802 | |
| r | 6802 | |
| M | 589 | 1.0% |
| o | 589 | 1.0% |
| b | 589 | 1.0% |
| i | 589 | 1.0% |
| l | 589 | 1.0% |
trip_type
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 3 | 3 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| RoundTrip | |
|---|---|
| OneWay | 366 |
| CircleTrip | 111 |
| RoundTrip | |
|---|---|
| OneWay | 20 |
| CircleTrip | 5 |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 10 | 10 |
| Median length | 9 | 9 |
| Mean length | 8.9764383 | 8.9925585 |
| Min length | 6 | 6 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 376023 | 66464 |
| Distinct characters | 17 | 17 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | RoundTrip | RoundTrip |
| 2nd row | RoundTrip | RoundTrip |
| 3rd row | RoundTrip | RoundTrip |
| 4th row | RoundTrip | RoundTrip |
| 5th row | RoundTrip | RoundTrip |
Common Values
| Value | Count | Frequency (%) |
| RoundTrip | 41413 | |
| OneWay | 366 | 0.9% |
| CircleTrip | 111 | 0.3% |
| Value | Count | Frequency (%) |
| RoundTrip | 7366 | |
| OneWay | 20 | 0.3% |
| CircleTrip | 5 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| roundtrip | 41413 | |
| oneway | 366 | 0.9% |
| circletrip | 111 | 0.3% |
| Value | Count | Frequency (%) |
| roundtrip | 7366 | |
| oneway | 20 | 0.3% |
| circletrip | 5 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 41779 | |
| r | 41635 | |
| i | 41635 | |
| p | 41524 | |
| T | 41524 | |
| o | 41413 | |
| R | 41413 | |
| d | 41413 | |
| u | 41413 | |
| e | 477 | 0.1% |
| Other values (7) | 1797 | 0.5% |
| Value | Count | Frequency (%) |
| n | 7386 | |
| r | 7376 | |
| i | 7376 | |
| p | 7371 | |
| T | 7371 | |
| o | 7366 | |
| R | 7366 | |
| d | 7366 | |
| u | 7366 | |
| e | 25 | < 0.1% |
| Other values (7) | 95 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 376023 |
| Value | Count | Frequency (%) |
| (unknown) | 66464 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 41779 | |
| r | 41635 | |
| i | 41635 | |
| p | 41524 | |
| T | 41524 | |
| o | 41413 | |
| R | 41413 | |
| d | 41413 | |
| u | 41413 | |
| e | 477 | 0.1% |
| Other values (7) | 1797 | 0.5% |
| Value | Count | Frequency (%) |
| n | 7386 | |
| r | 7376 | |
| i | 7376 | |
| p | 7371 | |
| T | 7371 | |
| o | 7366 | |
| R | 7366 | |
| d | 7366 | |
| u | 7366 | |
| e | 25 | < 0.1% |
| Other values (7) | 95 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 376023 |
| Value | Count | Frequency (%) |
| (unknown) | 66464 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 41779 | |
| r | 41635 | |
| i | 41635 | |
| p | 41524 | |
| T | 41524 | |
| o | 41413 | |
| R | 41413 | |
| d | 41413 | |
| u | 41413 | |
| e | 477 | 0.1% |
| Other values (7) | 1797 | 0.5% |
| Value | Count | Frequency (%) |
| n | 7386 | |
| r | 7376 | |
| i | 7376 | |
| p | 7371 | |
| T | 7371 | |
| o | 7366 | |
| R | 7366 | |
| d | 7366 | |
| u | 7366 | |
| e | 25 | < 0.1% |
| Other values (7) | 95 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 376023 |
| Value | Count | Frequency (%) |
| (unknown) | 66464 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 41779 | |
| r | 41635 | |
| i | 41635 | |
| p | 41524 | |
| T | 41524 | |
| o | 41413 | |
| R | 41413 | |
| d | 41413 | |
| u | 41413 | |
| e | 477 | 0.1% |
| Other values (7) | 1797 | 0.5% |
| Value | Count | Frequency (%) |
| n | 7386 | |
| r | 7376 | |
| i | 7376 | |
| p | 7371 | |
| T | 7371 | |
| o | 7366 | |
| R | 7366 | |
| d | 7366 | |
| u | 7366 | |
| e | 25 | < 0.1% |
| Other values (7) | 95 | 0.1% |
purchase_lead
Real number (ℝ)
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 467 | 424 |
| Distinct (%) | 1.1% | 5.7% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 85.563762 | 79.959681 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 0 |
| Maximum | 704 | 867 |
| Zeros | 324 | 41 |
| Zeros (%) | 0.8% | 0.6% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Quantile statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 0 |
| 5-th percentile | 4 | 3 |
| Q1 | 22 | 18 |
| median | 52 | 46 |
| Q3 | 116 | 106 |
| 95-th percentile | 288 | 282 |
| Maximum | 704 | 867 |
| Range | 704 | 867 |
| Interquartile range (IQR) | 94 | 88 |
Descriptive statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Standard deviation | 90.500332 | 89.755331 |
| Coefficient of variation (CV) | 1.0576946 | 1.1225074 |
| Kurtosis | 2.3817675 | 3.2434149 |
| Mean | 85.563762 | 79.959681 |
| Median Absolute Deviation (MAD) | 37 | 34 |
| Skewness | 1.6369537 | 1.7782196 |
| Sum | 3584266 | 590982 |
| Variance | 8190.3101 | 8056.0195 |
| Monotonicity | Not monotonic | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 579 | 1.4% |
| 2 | 546 | 1.3% |
| 6 | 531 | 1.3% |
| 5 | 516 | 1.2% |
| 7 | 514 | 1.2% |
| 13 | 487 | 1.2% |
| 9 | 486 | 1.2% |
| 8 | 483 | 1.2% |
| 18 | 481 | 1.1% |
| 12 | 479 | 1.1% |
| Other values (457) | 36788 |
| Value | Count | Frequency (%) |
| 7 | 122 | 1.7% |
| 2 | 120 | 1.6% |
| 4 | 119 | 1.6% |
| 6 | 118 | 1.6% |
| 13 | 117 | 1.6% |
| 3 | 111 | 1.5% |
| 15 | 110 | 1.5% |
| 8 | 108 | 1.5% |
| 20 | 104 | 1.4% |
| 10 | 103 | 1.4% |
| Other values (414) | 6259 |
| Value | Count | Frequency (%) |
| 0 | 324 | |
| 1 | 579 | |
| 2 | 546 | |
| 3 | 460 | |
| 4 | 478 | |
| 5 | 516 | |
| 6 | 531 | |
| 7 | 514 | |
| 8 | 483 | |
| 9 | 486 |
| Value | Count | Frequency (%) |
| 0 | 41 | 0.6% |
| 1 | 102 | |
| 2 | 120 | |
| 3 | 111 | |
| 4 | 119 | |
| 5 | 95 | |
| 6 | 118 | |
| 7 | 122 | |
| 8 | 108 | |
| 9 | 101 |
| Value | Count | Frequency (%) |
| 0 | 41 | 0.1% |
| 1 | 102 | |
| 2 | 120 | |
| 3 | 111 | |
| 4 | 119 | |
| 5 | 95 | |
| 6 | 118 | |
| 7 | 122 | |
| 8 | 108 | |
| 9 | 101 |
| Value | Count | Frequency (%) |
| 0 | 324 | |
| 1 | 579 | |
| 2 | 546 | |
| 3 | 460 | |
| 4 | 478 | |
| 5 | 516 | |
| 6 | 531 | |
| 7 | 514 | |
| 8 | 483 | |
| 9 | 486 |
length_of_stay
Real number (ℝ)
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 323 | 180 |
| Distinct (%) | 0.8% | 2.4% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 23.651969 | 19.664727 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 1 |
| Maximum | 773 | 778 |
| Zeros | 9 | 0 |
| Zeros (%) | < 0.1% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Quantile statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 1 |
| 5-th percentile | 3 | 3 |
| Q1 | 5 | 5 |
| median | 17 | 6 |
| Q3 | 29 | 23 |
| 95-th percentile | 84 | 81 |
| Maximum | 773 | 778 |
| Range | 773 | 777 |
| Interquartile range (IQR) | 24 | 18 |
Descriptive statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Standard deviation | 33.768309 | 33.995823 |
| Coefficient of variation (CV) | 1.4277166 | 1.7287716 |
| Kurtosis | 46.347977 | 67.595108 |
| Mean | 23.651969 | 19.664727 |
| Median Absolute Deviation (MAD) | 12 | 2 |
| Skewness | 5.173832 | 6.076089 |
| Sum | 990781 | 145342 |
| Variance | 1140.2987 | 1155.716 |
| Monotonicity | Not monotonic | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6 | 6020 | 14.4% |
| 5 | 5803 | 13.9% |
| 4 | 4537 | 10.8% |
| 3 | 2301 | 5.5% |
| 17 | 1630 | 3.9% |
| 21 | 1243 | 3.0% |
| 18 | 1197 | 2.9% |
| 22 | 1162 | 2.8% |
| 20 | 1147 | 2.7% |
| 19 | 1109 | 2.6% |
| Other values (313) | 15741 |
| Value | Count | Frequency (%) |
| 6 | 1591 | |
| 5 | 1348 | |
| 4 | 1031 | |
| 3 | 497 | 6.7% |
| 17 | 193 | 2.6% |
| 2 | 153 | 2.1% |
| 18 | 138 | 1.9% |
| 19 | 132 | 1.8% |
| 21 | 130 | 1.8% |
| 20 | 130 | 1.8% |
| Other values (170) | 2048 |
| Value | Count | Frequency (%) |
| 0 | 9 | < 0.1% |
| 1 | 208 | 0.5% |
| 2 | 704 | 1.7% |
| 3 | 2301 | 5.5% |
| 4 | 4537 | |
| 5 | 5803 | |
| 6 | 6020 | |
| 17 | 1630 | 3.9% |
| 18 | 1197 | 2.9% |
| 19 | 1109 | 2.6% |
| Value | Count | Frequency (%) |
| 1 | 49 | 0.7% |
| 2 | 153 | 2.1% |
| 3 | 497 | 6.7% |
| 4 | 1031 | |
| 5 | 1348 | |
| 6 | 1591 | |
| 17 | 193 | 2.6% |
| 18 | 138 | 1.9% |
| 19 | 132 | 1.8% |
| 20 | 130 | 1.8% |
| Value | Count | Frequency (%) |
| 1 | 49 | 0.1% |
| 2 | 153 | 0.4% |
| 3 | 497 | 1.2% |
| 4 | 1031 | |
| 5 | 1348 | |
| 6 | 1591 | |
| 17 | 193 | 0.5% |
| 18 | 138 | 0.3% |
| 19 | 132 | 0.3% |
| 20 | 130 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 9 | 0.1% |
| 1 | 208 | 2.8% |
| 2 | 704 | 9.5% |
| 3 | 2301 | 31.1% |
| 4 | 4537 | |
| 5 | 5803 | |
| 6 | 6020 | |
| 17 | 1630 | 22.1% |
| 18 | 1197 | 16.2% |
| 19 | 1109 | 15.0% |
flight_hour
Real number (ℝ)
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 24 | 24 |
| Distinct (%) | 0.1% | 0.3% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 9.0554309 | 9.1570829 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 0 |
| Maximum | 23 | 23 |
| Zeros | 1321 | 180 |
| Zeros (%) | 3.2% | 2.4% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Quantile statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 0 | 0 |
| 5-th percentile | 1 | 1 |
| Q1 | 5 | 5 |
| median | 9 | 9 |
| Q3 | 13 | 13 |
| 95-th percentile | 19 | 17 |
| Maximum | 23 | 23 |
| Range | 23 | 23 |
| Interquartile range (IQR) | 8 | 8 |
Descriptive statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Standard deviation | 5.4436652 | 5.2360082 |
| Coefficient of variation (CV) | 0.60114922 | 0.57179871 |
| Kurtosis | -0.27249414 | -0.48318059 |
| Mean | 9.0554309 | 9.1570829 |
| Median Absolute Deviation (MAD) | 4 | 4 |
| Skewness | 0.41738372 | 0.27901594 |
| Sum | 379332 | 67680 |
| Variance | 29.633491 | 27.415782 |
| Monotonicity | Not monotonic | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 11 | 2670 | 6.4% |
| 12 | 2663 | 6.4% |
| 7 | 2658 | 6.3% |
| 8 | 2647 | 6.3% |
| 10 | 2640 | 6.3% |
| 9 | 2590 | 6.2% |
| 13 | 2547 | 6.1% |
| 6 | 2528 | 6.0% |
| 5 | 2388 | 5.7% |
| 4 | 2367 | 5.7% |
| Other values (14) | 16192 |
| Value | Count | Frequency (%) |
| 9 | 507 | 6.9% |
| 13 | 499 | 6.8% |
| 14 | 485 | 6.6% |
| 6 | 482 | 6.5% |
| 8 | 478 | 6.5% |
| 12 | 451 | 6.1% |
| 5 | 429 | 5.8% |
| 7 | 422 | 5.7% |
| 4 | 419 | 5.7% |
| 10 | 410 | 5.5% |
| Other values (14) | 2809 |
| Value | Count | Frequency (%) |
| 0 | 1321 | |
| 1 | 1787 | |
| 2 | 2210 | |
| 3 | 2232 | |
| 4 | 2367 | |
| 5 | 2388 | |
| 6 | 2528 | |
| 7 | 2658 | |
| 8 | 2647 | |
| 9 | 2590 |
| Value | Count | Frequency (%) |
| 0 | 180 | 2.4% |
| 1 | 284 | |
| 2 | 386 | |
| 3 | 384 | |
| 4 | 419 | |
| 5 | 429 | |
| 6 | 482 | |
| 7 | 422 | |
| 8 | 478 | |
| 9 | 507 |
| Value | Count | Frequency (%) |
| 0 | 180 | 0.4% |
| 1 | 284 | |
| 2 | 386 | |
| 3 | 384 | |
| 4 | 419 | |
| 5 | 429 | |
| 6 | 482 | |
| 7 | 422 | |
| 8 | 478 | |
| 9 | 507 |
| Value | Count | Frequency (%) |
| 0 | 1321 | |
| 1 | 1787 | |
| 2 | 2210 | |
| 3 | 2232 | |
| 4 | 2367 | |
| 5 | 2388 | |
| 6 | 2528 | |
| 7 | 2658 | |
| 8 | 2647 | |
| 9 | 2590 |
flight_day
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 7 | 7 |
| Distinct (%) | < 0.1% | 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| Mon | |
|---|---|
| Tue | |
| Wed | |
| Thu | |
| Fri | |
| Other values (2) |
| Wed | |
|---|---|
| Mon | |
| Tue | |
| Thu | |
| Fri | |
| Other values (2) |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 3 | 3 |
| Median length | 3 | 3 |
| Mean length | 3 | 3 |
| Min length | 3 | 3 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 125670 | 22173 |
| Distinct characters | 15 | 15 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | Sat | Mon |
| 2nd row | Sat | Mon |
| 3rd row | Wed | Tue |
| 4th row | Sat | Tue |
| 5th row | Wed | Tue |
Common Values
| Value | Count | Frequency (%) |
| Mon | 6794 | |
| Tue | 6442 | |
| Wed | 6332 | |
| Thu | 6214 | |
| Fri | 5709 | |
| Sun | 5531 | |
| Sat | 4868 |
| Value | Count | Frequency (%) |
| Wed | 1230 | |
| Mon | 1194 | |
| Tue | 1116 | |
| Thu | 1109 | |
| Fri | 976 | |
| Sun | 911 | |
| Sat | 855 |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| mon | 6794 | |
| tue | 6442 | |
| wed | 6332 | |
| thu | 6214 | |
| fri | 5709 | |
| sun | 5531 | |
| sat | 4868 |
| Value | Count | Frequency (%) |
| wed | 1230 | |
| mon | 1194 | |
| tue | 1116 | |
| thu | 1109 | |
| fri | 976 | |
| sun | 911 | |
| sat | 855 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 18187 | |
| e | 12774 | |
| T | 12656 | |
| n | 12325 | |
| S | 10399 | 8.3% |
| M | 6794 | 5.4% |
| o | 6794 | 5.4% |
| W | 6332 | 5.0% |
| d | 6332 | 5.0% |
| h | 6214 | 4.9% |
| Other values (5) | 26863 |
| Value | Count | Frequency (%) |
| u | 3136 | |
| e | 2346 | |
| T | 2225 | |
| n | 2105 | |
| S | 1766 | 8.0% |
| W | 1230 | 5.5% |
| d | 1230 | 5.5% |
| M | 1194 | 5.4% |
| o | 1194 | 5.4% |
| h | 1109 | 5.0% |
| Other values (5) | 4638 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 125670 |
| Value | Count | Frequency (%) |
| (unknown) | 22173 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 18187 | |
| e | 12774 | |
| T | 12656 | |
| n | 12325 | |
| S | 10399 | 8.3% |
| M | 6794 | 5.4% |
| o | 6794 | 5.4% |
| W | 6332 | 5.0% |
| d | 6332 | 5.0% |
| h | 6214 | 4.9% |
| Other values (5) | 26863 |
| Value | Count | Frequency (%) |
| u | 3136 | |
| e | 2346 | |
| T | 2225 | |
| n | 2105 | |
| S | 1766 | 8.0% |
| W | 1230 | 5.5% |
| d | 1230 | 5.5% |
| M | 1194 | 5.4% |
| o | 1194 | 5.4% |
| h | 1109 | 5.0% |
| Other values (5) | 4638 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 125670 |
| Value | Count | Frequency (%) |
| (unknown) | 22173 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 18187 | |
| e | 12774 | |
| T | 12656 | |
| n | 12325 | |
| S | 10399 | 8.3% |
| M | 6794 | 5.4% |
| o | 6794 | 5.4% |
| W | 6332 | 5.0% |
| d | 6332 | 5.0% |
| h | 6214 | 4.9% |
| Other values (5) | 26863 |
| Value | Count | Frequency (%) |
| u | 3136 | |
| e | 2346 | |
| T | 2225 | |
| n | 2105 | |
| S | 1766 | 8.0% |
| W | 1230 | 5.5% |
| d | 1230 | 5.5% |
| M | 1194 | 5.4% |
| o | 1194 | 5.4% |
| h | 1109 | 5.0% |
| Other values (5) | 4638 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 125670 |
| Value | Count | Frequency (%) |
| (unknown) | 22173 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 18187 | |
| e | 12774 | |
| T | 12656 | |
| n | 12325 | |
| S | 10399 | 8.3% |
| M | 6794 | 5.4% |
| o | 6794 | 5.4% |
| W | 6332 | 5.0% |
| d | 6332 | 5.0% |
| h | 6214 | 4.9% |
| Other values (5) | 26863 |
| Value | Count | Frequency (%) |
| u | 3136 | |
| e | 2346 | |
| T | 2225 | |
| n | 2105 | |
| S | 1766 | 8.0% |
| W | 1230 | 5.5% |
| d | 1230 | 5.5% |
| M | 1194 | 5.4% |
| o | 1194 | 5.4% |
| h | 1109 | 5.0% |
| Other values (5) | 4638 |
route
['Text', 'Text']
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 786 | 549 |
| Distinct (%) | 1.9% | 7.4% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 6 | 6 |
| Median length | 6 | 6 |
| Mean length | 6 | 6 |
| Min length | 6 | 6 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 251340 | 44346 |
| Distinct characters | 26 | 26 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 66 | 103 ? |
| Unique (%) | 0.2% | 1.4% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | AKLDEL | AKLKUL |
| 2nd row | AKLDEL | AKLKUL |
| 3rd row | AKLDEL | AKLKUL |
| 4th row | AKLDEL | AKLKUL |
| 5th row | AKLDEL | AKLKUL |
| Value | Count | Frequency (%) |
| aklkul | 2061 | 4.9% |
| melsgn | 790 | 1.9% |
| icnsin | 704 | 1.7% |
| icnsyd | 678 | 1.6% |
| dmkper | 640 | 1.5% |
| meltpe | 623 | 1.5% |
| dmkool | 612 | 1.5% |
| dpsicn | 601 | 1.4% |
| sgnsyd | 548 | 1.3% |
| dmkkix | 544 | 1.3% |
| Other values (776) | 34089 |
| Value | Count | Frequency (%) |
| aklkul | 559 | 7.6% |
| pentpe | 396 | 5.4% |
| dmkkix | 185 | 2.5% |
| jhbktm | 163 | 2.2% |
| melpen | 136 | 1.8% |
| icnpen | 134 | 1.8% |
| ktmpen | 117 | 1.6% |
| cgkhnd | 105 | 1.4% |
| hndpen | 98 | 1.3% |
| cgkkix | 96 | 1.3% |
| Other values (539) | 5402 |
Most occurring characters
| Value | Count | Frequency (%) |
| K | 23777 | 9.5% |
| E | 23056 | 9.2% |
| P | 20416 | 8.1% |
| L | 17961 | 7.1% |
| D | 17852 | 7.1% |
| N | 17685 | 7.0% |
| S | 15759 | 6.3% |
| M | 15202 | 6.0% |
| C | 13511 | 5.4% |
| I | 11430 | 4.5% |
| Other values (16) | 74691 |
| Value | Count | Frequency (%) |
| K | 5208 | 11.7% |
| P | 4183 | 9.4% |
| E | 3982 | 9.0% |
| N | 3705 | 8.4% |
| L | 2681 | 6.0% |
| C | 2318 | 5.2% |
| I | 2312 | 5.2% |
| M | 2264 | 5.1% |
| D | 2184 | 4.9% |
| S | 2083 | 4.7% |
| Other values (16) | 13426 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 251340 |
| Value | Count | Frequency (%) |
| (unknown) | 44346 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| K | 23777 | 9.5% |
| E | 23056 | 9.2% |
| P | 20416 | 8.1% |
| L | 17961 | 7.1% |
| D | 17852 | 7.1% |
| N | 17685 | 7.0% |
| S | 15759 | 6.3% |
| M | 15202 | 6.0% |
| C | 13511 | 5.4% |
| I | 11430 | 4.5% |
| Other values (16) | 74691 |
| Value | Count | Frequency (%) |
| K | 5208 | 11.7% |
| P | 4183 | 9.4% |
| E | 3982 | 9.0% |
| N | 3705 | 8.4% |
| L | 2681 | 6.0% |
| C | 2318 | 5.2% |
| I | 2312 | 5.2% |
| M | 2264 | 5.1% |
| D | 2184 | 4.9% |
| S | 2083 | 4.7% |
| Other values (16) | 13426 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 251340 |
| Value | Count | Frequency (%) |
| (unknown) | 44346 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| K | 23777 | 9.5% |
| E | 23056 | 9.2% |
| P | 20416 | 8.1% |
| L | 17961 | 7.1% |
| D | 17852 | 7.1% |
| N | 17685 | 7.0% |
| S | 15759 | 6.3% |
| M | 15202 | 6.0% |
| C | 13511 | 5.4% |
| I | 11430 | 4.5% |
| Other values (16) | 74691 |
| Value | Count | Frequency (%) |
| K | 5208 | 11.7% |
| P | 4183 | 9.4% |
| E | 3982 | 9.0% |
| N | 3705 | 8.4% |
| L | 2681 | 6.0% |
| C | 2318 | 5.2% |
| I | 2312 | 5.2% |
| M | 2264 | 5.1% |
| D | 2184 | 4.9% |
| S | 2083 | 4.7% |
| Other values (16) | 13426 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 251340 |
| Value | Count | Frequency (%) |
| (unknown) | 44346 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| K | 23777 | 9.5% |
| E | 23056 | 9.2% |
| P | 20416 | 8.1% |
| L | 17961 | 7.1% |
| D | 17852 | 7.1% |
| N | 17685 | 7.0% |
| S | 15759 | 6.3% |
| M | 15202 | 6.0% |
| C | 13511 | 5.4% |
| I | 11430 | 4.5% |
| Other values (16) | 74691 |
| Value | Count | Frequency (%) |
| K | 5208 | 11.7% |
| P | 4183 | 9.4% |
| E | 3982 | 9.0% |
| N | 3705 | 8.4% |
| L | 2681 | 6.0% |
| C | 2318 | 5.2% |
| I | 2312 | 5.2% |
| M | 2264 | 5.1% |
| D | 2184 | 4.9% |
| S | 2083 | 4.7% |
| Other values (16) | 13426 |
booking_origin
['Text', 'Text']
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 100 | 58 |
| Distinct (%) | 0.2% | 0.8% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 20 | 20 |
| Median length | 16 | 15 |
| Mean length | 8.2920745 | 7.9238263 |
| Min length | 4 | 4 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 347355 | 58565 |
| Distinct characters | 53 | 50 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 24 | 16 ? |
| Unique (%) | 0.1% | 0.2% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | New Zealand | Malaysia |
| 2nd row | New Zealand | Malaysia |
| 3rd row | India | Singapore |
| 4th row | New Zealand | Malaysia |
| 5th row | India | Malaysia |
| Value | Count | Frequency (%) |
| australia | 16796 | |
| malaysia | 4621 | 9.6% |
| south | 4046 | 8.4% |
| korea | 4043 | 8.4% |
| japan | 3347 | 7.0% |
| china | 2600 | 5.4% |
| taiwan | 1822 | 3.8% |
| indonesia | 1708 | 3.6% |
| thailand | 1529 | 3.2% |
| india | 1130 | 2.4% |
| Other values (106) | 6342 | 13.2% |
| Value | Count | Frequency (%) |
| malaysia | 2434 | |
| australia | 895 | 11.0% |
| china | 684 | 8.4% |
| indonesia | 609 | 7.5% |
| japan | 472 | 5.8% |
| thailand | 464 | 5.7% |
| south | 459 | 5.6% |
| korea | 459 | 5.6% |
| singapore | 295 | 3.6% |
| taiwan | 220 | 2.7% |
| Other values (58) | 1134 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 75531 | |
| i | 33166 | |
| l | 24429 | 7.0% |
| s | 24012 | 6.9% |
| t | 22774 | 6.6% |
| r | 22251 | 6.4% |
| u | 21410 | 6.2% |
| n | 17915 | 5.2% |
| A | 16878 | 4.9% |
| o | 11397 | 3.3% |
| Other values (43) | 77592 |
| Value | Count | Frequency (%) |
| a | 14333 | |
| i | 6326 | |
| s | 4137 | 7.1% |
| n | 4120 | 7.0% |
| l | 3948 | 6.7% |
| M | 2547 | 4.3% |
| y | 2473 | 4.2% |
| o | 2049 | 3.5% |
| e | 1967 | 3.4% |
| t | 1804 | 3.1% |
| Other values (40) | 14861 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 347355 |
| Value | Count | Frequency (%) |
| (unknown) | 58565 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 75531 | |
| i | 33166 | |
| l | 24429 | 7.0% |
| s | 24012 | 6.9% |
| t | 22774 | 6.6% |
| r | 22251 | 6.4% |
| u | 21410 | 6.2% |
| n | 17915 | 5.2% |
| A | 16878 | 4.9% |
| o | 11397 | 3.3% |
| Other values (43) | 77592 |
| Value | Count | Frequency (%) |
| a | 14333 | |
| i | 6326 | |
| s | 4137 | 7.1% |
| n | 4120 | 7.0% |
| l | 3948 | 6.7% |
| M | 2547 | 4.3% |
| y | 2473 | 4.2% |
| o | 2049 | 3.5% |
| e | 1967 | 3.4% |
| t | 1804 | 3.1% |
| Other values (40) | 14861 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 347355 |
| Value | Count | Frequency (%) |
| (unknown) | 58565 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 75531 | |
| i | 33166 | |
| l | 24429 | 7.0% |
| s | 24012 | 6.9% |
| t | 22774 | 6.6% |
| r | 22251 | 6.4% |
| u | 21410 | 6.2% |
| n | 17915 | 5.2% |
| A | 16878 | 4.9% |
| o | 11397 | 3.3% |
| Other values (43) | 77592 |
| Value | Count | Frequency (%) |
| a | 14333 | |
| i | 6326 | |
| s | 4137 | 7.1% |
| n | 4120 | 7.0% |
| l | 3948 | 6.7% |
| M | 2547 | 4.3% |
| y | 2473 | 4.2% |
| o | 2049 | 3.5% |
| e | 1967 | 3.4% |
| t | 1804 | 3.1% |
| Other values (40) | 14861 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 347355 |
| Value | Count | Frequency (%) |
| (unknown) | 58565 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 75531 | |
| i | 33166 | |
| l | 24429 | 7.0% |
| s | 24012 | 6.9% |
| t | 22774 | 6.6% |
| r | 22251 | 6.4% |
| u | 21410 | 6.2% |
| n | 17915 | 5.2% |
| A | 16878 | 4.9% |
| o | 11397 | 3.3% |
| Other values (43) | 77592 |
| Value | Count | Frequency (%) |
| a | 14333 | |
| i | 6326 | |
| s | 4137 | 7.1% |
| n | 4120 | 7.0% |
| l | 3948 | 6.7% |
| M | 2547 | 4.3% |
| y | 2473 | 4.2% |
| o | 2049 | 3.5% |
| e | 1967 | 3.4% |
| t | 1804 | 3.1% |
| Other values (40) | 14861 |
wants_extra_baggage
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 2 | 2 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| 1 | |
|---|---|
| 0 |
| 1 | |
|---|---|
| 0 |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 1 | 1 |
| Median length | 1 | 1 |
| Mean length | 1 | 1 |
| Min length | 1 | 1 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 41890 | 7391 |
| Distinct characters | 2 | 2 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | 1 | 0 |
| 2nd row | 0 | 1 |
| 3rd row | 1 | 1 |
| 4th row | 0 | 1 |
| 5th row | 1 | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27425 | |
| 0 | 14465 |
| Value | Count | Frequency (%) |
| 1 | 5506 | |
| 0 | 1885 | 25.5% |
wants_preferred_seat
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 2 | 2 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| 0 | |
|---|---|
| 1 |
| 0 | |
|---|---|
| 1 |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 1 | 1 |
| Median length | 1 | 1 |
| Mean length | 1 | 1 |
| Min length | 1 | 1 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 41890 | 7391 |
| Distinct characters | 2 | 2 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | 0 | 0 |
| 2nd row | 0 | 0 |
| 3rd row | 1 | 0 |
| 4th row | 0 | 0 |
| 5th row | 0 | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 29909 | |
| 1 | 11981 |
| Value | Count | Frequency (%) |
| 0 | 4803 | |
| 1 | 2588 |
wants_in_flight_meals
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 2 | 2 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| 0 | |
|---|---|
| 1 |
| 0 | |
|---|---|
| 1 |
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 1 | 1 |
| Median length | 1 | 1 |
| Mean length | 1 | 1 |
| Min length | 1 | 1 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 41890 | 7391 |
| Distinct characters | 2 | 2 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | 0 | 0 |
| 2nd row | 0 | 0 |
| 3rd row | 0 | 1 |
| 4th row | 1 | 1 |
| 5th row | 1 | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 24248 | |
| 1 | 17642 |
| Value | Count | Frequency (%) |
| 0 | 4008 | |
| 1 | 3383 |
flight_duration
Real number (ℝ)
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 21 | 21 |
| Distinct (%) | 0.1% | 0.3% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 7.346932 | 6.9004749 |
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 4.67 | 4.67 |
| Maximum | 9.5 | 9.5 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
Quantile statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Minimum | 4.67 | 4.67 |
| 5-th percentile | 4.72 | 4.67 |
| Q1 | 5.62 | 5.52 |
| median | 7.57 | 6.62 |
| Q3 | 8.83 | 8.67 |
| 95-th percentile | 8.83 | 8.83 |
| Maximum | 9.5 | 9.5 |
| Range | 4.83 | 4.83 |
| Interquartile range (IQR) | 3.21 | 3.15 |
Descriptive statistics
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Standard deviation | 1.4806689 | 1.5281767 |
| Coefficient of variation (CV) | 0.20153568 | 0.22145964 |
| Kurtosis | -1.3420454 | -1.4050642 |
| Mean | 7.346932 | 6.9004749 |
| Median Absolute Deviation (MAD) | 1.26 | 1.55 |
| Skewness | -0.4194776 | -0.04400649 |
| Sum | 307762.98 | 51001.41 |
| Variance | 2.1923805 | 2.3353239 |
| Monotonicity | Not monotonic | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 8.83 | 12668 | |
| 8.58 | 6354 | |
| 5.62 | 4950 | 11.8% |
| 6.62 | 3859 | 9.2% |
| 7 | 2587 | 6.2% |
| 7.57 | 2287 | 5.5% |
| 4.67 | 2032 | 4.9% |
| 6.42 | 1339 | 3.2% |
| 5.33 | 1125 | 2.7% |
| 6.33 | 984 | 2.3% |
| Other values (11) | 3705 | 8.8% |
| Value | Count | Frequency (%) |
| 8.83 | 1671 | |
| 6.62 | 799 | |
| 7 | 727 | |
| 4.67 | 667 | 9.0% |
| 8.58 | 538 | 7.3% |
| 5.62 | 514 | 7.0% |
| 7.57 | 498 | 6.7% |
| 4.75 | 416 | 5.6% |
| 5.33 | 381 | 5.2% |
| 6.42 | 369 | 5.0% |
| Other values (11) | 811 |
| Value | Count | Frequency (%) |
| 4.67 | 2032 | |
| 4.72 | 369 | 0.9% |
| 4.75 | 830 | 2.0% |
| 4.83 | 126 | 0.3% |
| 5 | 180 | 0.4% |
| 5.07 | 382 | 0.9% |
| 5.13 | 88 | 0.2% |
| 5.33 | 1125 | 2.7% |
| 5.52 | 612 | 1.5% |
| 5.62 | 4950 |
| Value | Count | Frequency (%) |
| 4.67 | 667 | |
| 4.72 | 117 | 1.6% |
| 4.75 | 416 | |
| 4.83 | 19 | 0.3% |
| 5 | 57 | 0.8% |
| 5.07 | 119 | 1.6% |
| 5.13 | 28 | 0.4% |
| 5.33 | 381 | |
| 5.52 | 52 | 0.7% |
| 5.62 | 514 |
| Value | Count | Frequency (%) |
| 4.67 | 667 | |
| 4.72 | 117 | 0.3% |
| 4.75 | 416 | |
| 4.83 | 19 | < 0.1% |
| 5 | 57 | 0.1% |
| 5.07 | 119 | 0.3% |
| 5.13 | 28 | 0.1% |
| 5.33 | 381 | |
| 5.52 | 52 | 0.1% |
| 5.62 | 514 |
| Value | Count | Frequency (%) |
| 4.67 | 2032 | |
| 4.72 | 369 | 5.0% |
| 4.75 | 830 | 11.2% |
| 4.83 | 126 | 1.7% |
| 5 | 180 | 2.4% |
| 5.07 | 382 | 5.2% |
| 5.13 | 88 | 1.2% |
| 5.33 | 1125 | 15.2% |
| 5.52 | 612 | 8.3% |
| 5.62 | 4950 |
booking_complete
Categorical
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Distinct | 1 | 1 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 654.5 KiB | 115.5 KiB |
| 0 |
|---|
| 1 |
|---|
Length
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Max length | 1 | 1 |
| Median length | 1 | 1 |
| Mean length | 1 | 1 |
| Min length | 1 | 1 |
Characters and Unicode
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Total characters | 41890 | 7391 |
| Distinct characters | 1 | 1 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Profiling Report: Incomplete Bookings | Profiling Report: Complete Bookings | |
|---|---|---|
| 1st row | 0 | 1 |
| 2nd row | 0 | 1 |
| 3rd row | 0 | 1 |
| 4th row | 0 | 1 |
| 5th row | 0 | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Length
Histogram of lengths of the category
Common Values (Plot)
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41890 |
| Value | Count | Frequency (%) |
| (unknown) | 7391 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 41890 |
| Value | Count | Frequency (%) |
| 1 | 7391 |
Interactions
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Correlations
Profiling Report: Incomplete Bookings
Profiling Report: Complete Bookings
Profiling Report: Incomplete Bookings
| flight_day | flight_duration | flight_hour | length_of_stay | num_passengers | purchase_lead | sales_channel | trip_type | wants_extra_baggage | wants_in_flight_meals | wants_preferred_seat | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| flight_day | 1.000 | 0.019 | 0.028 | 0.007 | 0.015 | 0.052 | 0.050 | 0.004 | 0.000 | 0.006 | 0.012 |
| flight_duration | 0.019 | 1.000 | -0.031 | 0.241 | -0.063 | 0.067 | 0.072 | 0.032 | 0.115 | 0.177 | 0.130 |
| flight_hour | 0.028 | -0.031 | 1.000 | -0.047 | 0.025 | 0.038 | 0.034 | 0.006 | 0.030 | 0.028 | 0.033 |
| length_of_stay | 0.007 | 0.241 | -0.047 | 1.000 | -0.121 | 0.025 | 0.031 | 0.000 | 0.108 | 0.070 | 0.037 |
| num_passengers | 0.015 | -0.063 | 0.025 | -0.121 | 1.000 | 0.255 | 0.014 | 0.000 | 0.130 | 0.026 | 0.052 |
| purchase_lead | 0.052 | 0.067 | 0.038 | 0.025 | 0.255 | 1.000 | 0.021 | 0.000 | 0.065 | 0.045 | 0.021 |
| sales_channel | 0.050 | 0.072 | 0.034 | 0.031 | 0.014 | 0.021 | 1.000 | 0.024 | 0.056 | 0.031 | 0.029 |
| trip_type | 0.004 | 0.032 | 0.006 | 0.000 | 0.000 | 0.000 | 0.024 | 1.000 | 0.018 | 0.013 | 0.004 |
| wants_extra_baggage | 0.000 | 0.115 | 0.030 | 0.108 | 0.130 | 0.065 | 0.056 | 0.018 | 1.000 | 0.222 | 0.209 |
| wants_in_flight_meals | 0.006 | 0.177 | 0.028 | 0.070 | 0.026 | 0.045 | 0.031 | 0.013 | 0.222 | 1.000 | 0.310 |
| wants_preferred_seat | 0.012 | 0.130 | 0.033 | 0.037 | 0.052 | 0.021 | 0.029 | 0.004 | 0.209 | 0.310 | 1.000 |
Profiling Report: Complete Bookings
| flight_day | flight_duration | flight_hour | length_of_stay | num_passengers | purchase_lead | sales_channel | trip_type | wants_extra_baggage | wants_in_flight_meals | wants_preferred_seat | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| flight_day | 1.000 | 0.021 | 0.032 | 0.000 | 0.023 | 0.059 | 0.020 | 0.017 | 0.000 | 0.000 | 0.028 |
| flight_duration | 0.021 | 1.000 | 0.014 | 0.145 | -0.013 | 0.126 | 0.046 | 0.140 | 0.058 | 0.150 | 0.141 |
| flight_hour | 0.032 | 0.014 | 1.000 | -0.045 | 0.026 | 0.070 | 0.017 | 0.012 | 0.026 | 0.026 | 0.000 |
| length_of_stay | 0.000 | 0.145 | -0.045 | 1.000 | -0.128 | 0.024 | 0.000 | 0.000 | 0.085 | 0.036 | 0.010 |
| num_passengers | 0.023 | -0.013 | 0.026 | -0.128 | 1.000 | 0.269 | 0.000 | 0.055 | 0.137 | 0.039 | 0.067 |
| purchase_lead | 0.059 | 0.126 | 0.070 | 0.024 | 0.269 | 1.000 | 0.025 | 0.000 | 0.009 | 0.022 | 0.000 |
| sales_channel | 0.020 | 0.046 | 0.017 | 0.000 | 0.000 | 0.025 | 1.000 | 0.000 | 0.030 | 0.014 | 0.043 |
| trip_type | 0.017 | 0.140 | 0.012 | 0.000 | 0.055 | 0.000 | 0.000 | 1.000 | 0.031 | 0.000 | 0.000 |
| wants_extra_baggage | 0.000 | 0.058 | 0.026 | 0.085 | 0.137 | 0.009 | 0.030 | 0.031 | 1.000 | 0.174 | 0.188 |
| wants_in_flight_meals | 0.000 | 0.150 | 0.026 | 0.036 | 0.039 | 0.022 | 0.014 | 0.000 | 0.174 | 1.000 | 0.336 |
| wants_preferred_seat | 0.028 | 0.141 | 0.000 | 0.010 | 0.067 | 0.000 | 0.043 | 0.000 | 0.188 | 0.336 | 1.000 |
Missing values
Profiling Report: Incomplete Bookings
A simple visualization of nullity by column.
Profiling Report: Complete Bookings
A simple visualization of nullity by column.
Profiling Report: Incomplete Bookings
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Profiling Report: Complete Bookings
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
Profiling Report: Incomplete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | Internet | RoundTrip | 262 | 19 | 7 | Sat | AKLDEL | New Zealand | 1 | 0 | 0 | 5.52 | 0 |
| 1 | 1 | Internet | RoundTrip | 112 | 20 | 3 | Sat | AKLDEL | New Zealand | 0 | 0 | 0 | 5.52 | 0 |
| 2 | 2 | Internet | RoundTrip | 243 | 22 | 17 | Wed | AKLDEL | India | 1 | 1 | 0 | 5.52 | 0 |
| 3 | 1 | Internet | RoundTrip | 96 | 31 | 4 | Sat | AKLDEL | New Zealand | 0 | 0 | 1 | 5.52 | 0 |
| 4 | 2 | Internet | RoundTrip | 68 | 22 | 15 | Wed | AKLDEL | India | 1 | 0 | 1 | 5.52 | 0 |
| 5 | 1 | Internet | RoundTrip | 3 | 48 | 20 | Thu | AKLDEL | New Zealand | 1 | 0 | 1 | 5.52 | 0 |
| 6 | 3 | Internet | RoundTrip | 201 | 33 | 6 | Thu | AKLDEL | New Zealand | 1 | 0 | 1 | 5.52 | 0 |
| 7 | 2 | Internet | RoundTrip | 238 | 19 | 14 | Mon | AKLDEL | India | 1 | 0 | 1 | 5.52 | 0 |
| 8 | 1 | Internet | RoundTrip | 80 | 22 | 4 | Mon | AKLDEL | New Zealand | 0 | 0 | 1 | 5.52 | 0 |
| 9 | 1 | Mobile | RoundTrip | 378 | 30 | 12 | Sun | AKLDEL | India | 0 | 0 | 0 | 5.52 | 0 |
Profiling Report: Complete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82 | 1 | Internet | RoundTrip | 15 | 31 | 17 | Mon | AKLKUL | Malaysia | 0 | 0 | 0 | 8.83 | 1 |
| 86 | 1 | Internet | RoundTrip | 156 | 19 | 14 | Mon | AKLKUL | Malaysia | 1 | 0 | 0 | 8.83 | 1 |
| 94 | 1 | Internet | RoundTrip | 181 | 87 | 2 | Tue | AKLKUL | Singapore | 1 | 0 | 1 | 8.83 | 1 |
| 109 | 1 | Mobile | RoundTrip | 127 | 17 | 16 | Tue | AKLKUL | Malaysia | 1 | 0 | 1 | 8.83 | 1 |
| 122 | 1 | Internet | RoundTrip | 42 | 17 | 14 | Tue | AKLKUL | Malaysia | 0 | 0 | 0 | 8.83 | 1 |
| 124 | 1 | Internet | RoundTrip | 22 | 180 | 13 | Thu | AKLKUL | Malaysia | 1 | 0 | 0 | 8.83 | 1 |
| 136 | 3 | Internet | RoundTrip | 229 | 17 | 13 | Mon | AKLKUL | Malaysia | 1 | 1 | 1 | 8.83 | 1 |
| 152 | 1 | Internet | RoundTrip | 10 | 91 | 23 | Tue | AKLKUL | Singapore | 1 | 0 | 0 | 8.83 | 1 |
| 158 | 1 | Internet | RoundTrip | 99 | 21 | 13 | Sun | AKLKUL | Singapore | 0 | 0 | 0 | 8.83 | 1 |
| 168 | 1 | Internet | RoundTrip | 142 | 124 | 9 | Wed | AKLKUL | Malaysia | 1 | 0 | 0 | 8.83 | 1 |
Profiling Report: Incomplete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49990 | 1 | Internet | RoundTrip | 12 | 6 | 10 | Sat | PERPNH | Australia | 0 | 0 | 0 | 5.62 | 0 |
| 49991 | 1 | Internet | RoundTrip | 8 | 6 | 6 | Mon | PERPNH | Australia | 0 | 1 | 0 | 5.62 | 0 |
| 49992 | 1 | Internet | RoundTrip | 14 | 6 | 12 | Fri | PERPNH | Australia | 1 | 0 | 0 | 5.62 | 0 |
| 49993 | 1 | Internet | RoundTrip | 19 | 6 | 12 | Sun | PERPNH | Australia | 1 | 0 | 0 | 5.62 | 0 |
| 49994 | 2 | Internet | RoundTrip | 25 | 6 | 9 | Sun | PERPNH | Australia | 0 | 0 | 0 | 5.62 | 0 |
| 49995 | 2 | Internet | RoundTrip | 27 | 6 | 9 | Sat | PERPNH | Australia | 1 | 0 | 1 | 5.62 | 0 |
| 49996 | 1 | Internet | RoundTrip | 111 | 6 | 4 | Sun | PERPNH | Australia | 0 | 0 | 0 | 5.62 | 0 |
| 49997 | 1 | Internet | RoundTrip | 24 | 6 | 22 | Sat | PERPNH | Australia | 0 | 0 | 1 | 5.62 | 0 |
| 49998 | 1 | Internet | RoundTrip | 15 | 6 | 11 | Mon | PERPNH | Australia | 1 | 0 | 1 | 5.62 | 0 |
| 49999 | 1 | Internet | RoundTrip | 19 | 6 | 10 | Thu | PERPNH | Australia | 0 | 1 | 0 | 5.62 | 0 |
Profiling Report: Complete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49966 | 2 | Internet | RoundTrip | 23 | 6 | 0 | Thu | PENTPE | Italy | 1 | 1 | 1 | 4.67 | 1 |
| 49967 | 3 | Internet | RoundTrip | 279 | 6 | 13 | Fri | PENTPE | Malaysia | 1 | 0 | 0 | 4.67 | 1 |
| 49968 | 1 | Internet | RoundTrip | 25 | 6 | 12 | Fri | PENTPE | Taiwan | 0 | 0 | 0 | 4.67 | 1 |
| 49970 | 2 | Internet | RoundTrip | 52 | 6 | 10 | Sun | PENTPE | Malaysia | 1 | 1 | 1 | 4.67 | 1 |
| 49971 | 2 | Mobile | RoundTrip | 38 | 6 | 1 | Sat | PENTPE | Malaysia | 0 | 0 | 1 | 4.67 | 1 |
| 49972 | 1 | Internet | RoundTrip | 33 | 6 | 6 | Wed | PENTPE | Taiwan | 1 | 1 | 0 | 4.67 | 1 |
| 49977 | 2 | Internet | RoundTrip | 15 | 6 | 16 | Tue | PENTPE | Malaysia | 1 | 1 | 1 | 4.67 | 1 |
| 49980 | 4 | Internet | RoundTrip | 242 | 6 | 9 | Tue | PENXIY | Malaysia | 1 | 0 | 1 | 5.00 | 1 |
| 49984 | 2 | Internet | RoundTrip | 7 | 6 | 4 | Wed | PERPNH | Australia | 0 | 0 | 0 | 5.62 | 1 |
| 49987 | 3 | Internet | RoundTrip | 243 | 6 | 12 | Fri | PERPNH | Australia | 1 | 0 | 1 | 5.62 | 1 |
Duplicate rows
Profiling Report: Incomplete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dataset does not contain duplicate rows. | |||||||||||||||
Profiling Report: Complete Bookings
| num_passengers | sales_channel | trip_type | purchase_lead | length_of_stay | flight_hour | flight_day | route | booking_origin | wants_extra_baggage | wants_preferred_seat | wants_in_flight_meals | flight_duration | booking_complete | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dataset does not contain duplicate rows. | |||||||||||||||